Calculated Column Walkthrough
In this example a new virtual calculated column, [Sales Line Total] will be created based on two existing numeric attributes, [Quantity] and [Price].
Step 1
Drag a Model Attribute block onto the canvas:
Step 2
Open the Dimension Table and select the Model Attribute required.
Step 3
Add further Model Attributes, operators, functions etc. to complete your calculation logic
Step 4
Complete the Settings Panel to reflect the properties required
Step 5
Click on the Preview button to inspect the calculated column results. The calculation appears correct.
Step 6
To save the new Calculated Column into the Model, click on the Apply button.
Step 7
The new Calculated Column will appear in the list of columns for the table concerned. It can be configured using the same tools as any other column in the table.